<?php

$con=mysqli_connect("localhost","root","admin");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

// Create table
$sql= "CREATE TABLE HOPEWw.Employee(
  emp_ID INT NOT NULL AUTO_INCREMENT,
  emp_Name VARCHAR(40) NOT NULL,
  emp_Surname VARCHAR(40) NOT NULL,
  emp_PASS_ID_NO VARCHAR (40) NOT NULL, 
  emp_Email VARCHAR (40) NOT NULL,
  emp_UserType VARCHAR (40) NOT NULL,
  emp_Username VARCHAR (40) NOT NULL,
  emp_Password CHAR (32) NOT NULL,
    PRIMARY KEY ( emp_ID )
   )";
// Execute query
if (mysqli_query($con,$sql))
  {
  echo "Table Employee created successfully";
  }
else
  {
  echo "Error creating table: " . mysqli_error($con);
  }
  
 
?>
